create table if not exists d_rnt_wimp_rm_hotspot_info_d_#{PARTITION_DATE}
 (
hotspot_id    varchar(256) ,
nas_id    varchar(20) ,
hotspot_name    varchar(128) ,
city    varchar(20) ,
district    varchar(20) ,
ac_name    varchar(256) ,
ac_ip    varchar(20) ,
location_info    varchar(128) ,
coverage_type    varchar(32) ,
sub_coverage_type    varchar(32) ,
coverage_scene    varchar(256) ,
vip_level    bigint ,
longtitude    bigint ,
latitude    bigint ,
trans_type    varchar(20) ,
trans_bandwith    bigint ,
ap_number    bigint ,
switch_number    bigint ,
project_name    varchar(128) ,
project_no    varchar(32) ,
imp_vendor    varchar(64) ,
maint_vendor    varchar(64) ,
accept_flag    bigint ,
project_acceptor    varchar(64) ,
project_accept_date    datetime ,
project_complete_date    datetime ,
customer_name    varchar(64) ,
customer_phone    varchar(64) ,
rent_info    varchar(128) ,
fare_info    varchar(128) ,
rebark    varchar(128) ,
project_status    varchar(20) ,
create_date    datetime
)   compress(5, 5)  nolock ;